{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import sys\n",
    "sys.path.append('..')\n",
    "from configure.settings import DBSelector"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "outputs": [],
   "source": [
    "db=DBSelector().mongo('qq')\n"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "doc=db['db_stock']['danjuan_fund']"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "plan_list =[]\n",
    "for item in doc.find():\n",
    "    plan_name=item['plan_name']\n",
    "    holding=item['holding']\n",
    "    d={}\n",
    "    d[plan_name]=holding\n",
    "    plan_list.append(d)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "len(plan_list)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "plan_list[0]"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "fund_dict={}\n",
    "for item in plan_list:\n",
    "    name=list(item.keys())[0]\n",
    "    funds=item[name]\n",
    "    for fund in funds:\n",
    "        # if fund['percent']!=0:\n",
    "        fund_dict.setdefault(fund['fd_name'],set())\n",
    "        fund_dict[fund['fd_name']].add(name)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "result={}\n",
    "for item in fund_dict:\n",
    "    print(item,len(fund_dict[item]))\n",
    "    result[item]=len(fund_dict[item])"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "list(sorted(result.items(),key=lambda x:x[1],reverse=True))"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "help(sorted)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "result_=list(sorted(result.items(),key=lambda x:x[1],reverse=True))"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "result_dict_=[]\n",
    "for name,count in result_:\n",
    "    d={}\n",
    "    d['name']=name\n",
    "    d['count']=count\n",
    "    result_dict_.append(d)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "import pandas as pd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "result_dict_"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "df = pd.DataFrame(result_dict_)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "df.head()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "df.to_excel('fund_count_.xls',encoding='utf8')"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "import numpy as np"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "found_day_list=[]\n",
    "for item in doc.find({},{'found_days':1}):\n",
    "    found_day_list.append(item['found_days'])"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "print(np.array(found_day_list).mean())"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "result_np.mean()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "plan_list =[]\n",
    "for item in doc.find():\n",
    "    plan_name=item['plan_name']\n",
    "    holding=item['holding']\n",
    "    d={}\n",
    "    d[plan_name]=holding\n",
    "    plan_list.append(d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "134"
      ]
     },
     "metadata": {},
     "execution_count": 5
    }
   ],
   "source": [
    "len(plan_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "{'螺丝钉指数基金组合': [{'fd_code': '003318',\n",
       "   'fd_name': '景顺长城中证500低波动',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 12.21,\n",
       "   'total_gain_rate': 34.2128},\n",
       "  {'fd_code': '164906',\n",
       "   'fd_name': '交银中证海外中国互联网指数',\n",
       "   'type_desc': 'QDII型',\n",
       "   'type': 'qdii',\n",
       "   'percent': 11.39,\n",
       "   'total_gain_rate': 92.76259999999999},\n",
       "  {'fd_code': '001406',\n",
       "   'fd_name': '东方红策略精选C',\n",
       "   'type_desc': '混合型',\n",
       "   'type': 'hybrid',\n",
       "   'percent': 8.27,\n",
       "   'total_gain_rate': 1.294},\n",
       "  {'fd_code': '006586',\n",
       "   'fd_name': '南方安裕混合C',\n",
       "   'type_desc': '混合型',\n",
       "   'type': 'hybrid',\n",
       "   'percent': 7.61,\n",
       "   'total_gain_rate': -0.3519},\n",
       "  {'fd_code': '006327',\n",
       "   'fd_name': '易方达中概互联50ETF联接人民币A',\n",
       "   'type_desc': 'QDII型',\n",
       "   'type': 'qdii',\n",
       "   'percent': 7.57,\n",
       "   'total_gain_rate': 50.16890000000001},\n",
       "  {'fd_code': '161128',\n",
       "   'fd_name': '易方达标普信息科技',\n",
       "   'type_desc': 'QDII型',\n",
       "   'type': 'qdii',\n",
       "   'percent': 7.18,\n",
       "   'total_gain_rate': 30.4336},\n",
       "  {'fd_code': '006585',\n",
       "   'fd_name': '南方宝元债券C',\n",
       "   'type_desc': '债券型',\n",
       "   'type': 'bond',\n",
       "   'percent': 6.93,\n",
       "   'total_gain_rate': 4.9699},\n",
       "  {'fd_code': '090010',\n",
       "   'fd_name': '大成中证红利指数A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 6.07,\n",
       "   'total_gain_rate': 21.2486},\n",
       "  {'fd_code': '100032',\n",
       "   'fd_name': '富国中证红利指数增强',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 5.01,\n",
       "   'total_gain_rate': 34.3354},\n",
       "  {'fd_code': '501050',\n",
       "   'fd_name': '华夏上证50AH优选指数（LOF）A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 4.9,\n",
       "   'total_gain_rate': 20.8073},\n",
       "  {'fd_code': '519671',\n",
       "   'fd_name': '银河沪深300价值指数',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 4.77,\n",
       "   'total_gain_rate': 23.9742},\n",
       "  {'fd_code': '006060',\n",
       "   'fd_name': '鹏扬泓利债券C',\n",
       "   'type_desc': '债券型',\n",
       "   'type': 'bond',\n",
       "   'percent': 4.27,\n",
       "   'total_gain_rate': 3.6461},\n",
       "  {'fd_code': '485011',\n",
       "   'fd_name': '工银双利债券B',\n",
       "   'type_desc': '债券型',\n",
       "   'type': 'bond',\n",
       "   'percent': 2.89,\n",
       "   'total_gain_rate': 0.8126},\n",
       "  {'fd_code': '001594',\n",
       "   'fd_name': '天弘中证银行指数A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 1.89,\n",
       "   'total_gain_rate': 21.3651},\n",
       "  {'fd_code': '110031',\n",
       "   'fd_name': '易方达H股ETF联接',\n",
       "   'type_desc': 'QDII型',\n",
       "   'type': 'qdii',\n",
       "   'percent': 1.69,\n",
       "   'total_gain_rate': 27.4416},\n",
       "  {'fd_code': '160716',\n",
       "   'fd_name': '嘉实基本面50指数(LOF)A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 1.6,\n",
       "   'total_gain_rate': 58.5325},\n",
       "  {'fd_code': '008127',\n",
       "   'fd_name': '广发趋势优选混合C',\n",
       "   'type_desc': '混合型',\n",
       "   'type': 'hybrid',\n",
       "   'percent': 1.52,\n",
       "   'total_gain_rate': 1.9698},\n",
       "  {'fd_code': '501021',\n",
       "   'fd_name': '华宝香港中小',\n",
       "   'type_desc': 'QDII型',\n",
       "   'type': 'qdii',\n",
       "   'percent': 1.46,\n",
       "   'total_gain_rate': 34.732},\n",
       "  {'fd_code': '070023',\n",
       "   'fd_name': '嘉实深证基本面120联接',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 1.44,\n",
       "   'total_gain_rate': 65.225},\n",
       "  {'fd_code': '110003',\n",
       "   'fd_name': '易方达上证50指数A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0.92,\n",
       "   'total_gain_rate': 49.3477},\n",
       "  {'fd_code': '310398',\n",
       "   'fd_name': '申万菱信沪深300价值指数',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0.37,\n",
       "   'total_gain_rate': 35.1811},\n",
       "  {'fd_code': '008975',\n",
       "   'fd_name': '富国中证消费50ETF联接A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0.04,\n",
       "   'total_gain_rate': 65.2204},\n",
       "  {'fd_code': '161725',\n",
       "   'fd_name': '招商中证白酒指数',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': 58.114},\n",
       "  {'fd_code': '040046',\n",
       "   'fd_name': '华安纳斯达克100指数',\n",
       "   'type_desc': 'QDII型',\n",
       "   'type': 'qdii',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': 50.47430000000001},\n",
       "  {'fd_code': '000968',\n",
       "   'fd_name': '广发中证养老',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': 40.7162},\n",
       "  {'fd_code': '001550',\n",
       "   'fd_name': '天弘中证医药100A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': 31.3658},\n",
       "  {'fd_code': '530015',\n",
       "   'fd_name': '建信深证基本面60ETF联接A',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': 20.3643},\n",
       "  {'fd_code': '002086',\n",
       "   'fd_name': '大成景安短融债券E',\n",
       "   'type_desc': '债券型',\n",
       "   'type': 'bond',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': 0.28800000000000003},\n",
       "  {'fd_code': '501029',\n",
       "   'fd_name': '华宝红利基金',\n",
       "   'type_desc': '指数型',\n",
       "   'type': 'index',\n",
       "   'percent': 0,\n",
       "   'total_gain_rate': -3.1023}]}"
      ]
     },
     "metadata": {},
     "execution_count": 6
    }
   ],
   "source": [
    "plan_list[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "fund_dict={}\n",
    "for item in plan_list:\n",
    "    name=list(item.keys())[0]\n",
    "    funds=item[name]\n",
    "    for fund in funds:\n",
    "        # if fund['percent']!=0:\n",
    "        fund_dict.setdefault(fund['fd_name'],set())\n",
    "        fund_dict[fund['fd_name']].add(name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "景顺长城中证500低波动 11\n交银中证海外中国互联网指数 16\n东方红策略精选C 1\n南方安裕混合C 1\n易方达中概互联50ETF联接人民币A 19\n易方达标普信息科技 4\n南方宝元债券C 4\n大成中证红利指数A 13\n富国中证红利指数增强 13\n华夏上证50AH优选指数（LOF）A 15\n银河沪深300价值指数 9\n鹏扬泓利债券C 4\n工银双利债券B 2\n天弘中证银行指数A 10\n易方达H股ETF联接 9\n嘉实基本面50指数(LOF)A 5\n广发趋势优选混合C 1\n华宝香港中小 13\n嘉实深证基本面120联接 6\n易方达上证50指数A 11\n申万菱信沪深300价值指数 2\n富国中证消费50ETF联接A 4\n招商中证白酒指数 9\n华安纳斯达克100指数 7\n广发中证养老 5\n天弘中证医药100A 5\n建信深证基本面60ETF联接A 5\n大成景安短融债券E 1\n华宝红利基金 8\n中欧时代先锋股票C 1\n中欧行业成长混合（LOF）C 1\n中欧新动力混合（LOF）C 1\n中欧价值发现混合C 3\n中欧明睿新起点混合 1\n中欧数据挖掘混合C 1\n中欧养老混合 2\n中欧医疗健康混合C 1\n中欧消费主题股票C 2\n中欧新蓝筹混合C 1\n中欧丰泓沪港深C 1\n中欧明睿新常态混合 3\n中欧盛世成长混合(LOF)C 1\n中欧新蓝筹混合A 9\n诺安研究精选股票 2\n鹏华新兴产业混合 5\n前海开源再融资股票 1\n国泰聚信价值优势C 6\n工银金融地产混合 18\n南方香港成长 2\n前海开源沪港深优势精选 5\n富国互联科技股票 1\n银华体育文化混合 1\n中欧品质消费股票A 2\n易方达亚洲精选 5\n博时军工主题股票 4\n中欧价值发现混合A 7\n交银新生活力混合 10\n嘉实新能源新材料A 2\n华安中证全指证券公司指数 3\n创金合信医疗保健股票A 3\n富国蓝筹精选股票 1\n上投摩根中国生物医药(QDII) 2\n华宝创新混合 2\n嘉实港股通新经济指数A 9\n南方中证有色金属联接C 2\n西部利得中证500指数增强C 1\n华安黄金易ETF联接A 7\n方正富邦红利精选 1\n长城环保主题混合 1\n景顺长城能源基建 4\n上投摩根科技前沿混合 1\n富国中证新能源汽车指数 7\n华安沪深300增强 1\n万家经济新动能混合C 1\n南方500信息联接 4\n国泰中证申万证券行业指数 5\n国联安半导体ETF联接C 3\n天弘中证计算机指数C 2\n天弘中证500指数增强A 5\n国泰中证全指通信设备ETF联接基金C 3\n长信军工量化混合 3\n申万菱信中证500指数优选增强 3\n富国沪深300增强 7\n天弘医疗健康混合C 1\n天弘医疗健康混合A 1\n创金合信中证500指数增强C 1\n方正富邦消费红利指数增强（LOF） 1\n申万菱信沪深300指数增强 1\n天弘中证500指数A 2\n广发沪深300指数增强C 2\n广发中证基建工程指数C 4\n申万菱信中证500指数增强 5\n申万菱信中证500指数优选增强C 1\n鹏华中证传媒指数(LOF) 6\n汇添富中证环境治理指数A 1\n广发沪深300指数增强A 1\n前海联合沪深300指数A 1\n兴全商业模式优选 11\n富国天惠成长LOF 18\n国富大中华精选混合(QDII)人民币 5\n国富沪港深成长精选股票 10\n交银新成长混合 14\n易方达安盈回报混合 3\n汇添富价值精选混合 14\n中欧新动力混合A 5\n泓德远见回报混合 4\n招商沪深300地产等权重指数 9\n工银文体产业股票 11\n兴全合宜混合（LOF）A 8\n鹏华中证全指证券公司指数(LOF) 4\n南方原油 5\n安信价值精选股票 2\n泓德泓益混合 2\n东方红沪港深混合 1\n汇添富全球移动互联网 5\n鹏扬景升混合A 1\n华宝中证银行ETF联接A 6\n华夏恒生ETF联接 15\n万家新利混合 2\n南方中证全指证券联接A 4\n财通价值动量混合 1\n中欧新动力混合 1\n中银转债增强债券A 1\n诺安成长混合 1\n博时裕隆混合 1\n天弘越南市场股票A 2\n广发全球精选股票 4\n国泰深证TMT50指数 3\n嘉实新兴产业 5\n中欧时代先锋 9\n华安德国30（DAX）ETF联接 7\n广发中证全指建筑材料指数A 4\n兴全沪深300指数增强A 9\n华安媒体互联网混合 6\n工银全球精选股票 2\n兴全可转债 6\n博时信用债券A 5\n交银医药创新股票 1\n信达澳银精华配置 2\n华泰柏瑞量化阿尔法 2\n兴全趋势 16\n前海开源金银珠宝 1\n华夏海外收益债券C 1\n兴全合润混合 16\n博时亚洲票息收益债 3\n易方达安心回报债A 6\n中海可转换债券A 1\n嘉实原油 2\n鹏华全球高收益债 2\n富国中证500指数增强 15\n易方达蓝筹精选混合 25\n东方红睿丰混合 1\n广发稳健增长混合A类 19\n中欧潜力价值混合 5\n景顺长城新兴成长 6\n兴全轻资产 2\n兴全合泰混合A 2\n兴全绿色投资 1\n兴全精选混合 3\n兴全社会责任 2\n兴全全球视野股票 2\n兴全有机增长 1\n兴全合泰混合C 1\n华安沪港深外延增长 1\n申万菱信中证申万电子行业投资指数（LOF）A 2\n鹏华文化传媒娱乐 1\n易方达沪深300量化增强 2\n工银深证红利ETF联接C 4\n易方达安心回报债B 2\n富国收益宝货币B 1\n易方达稳健收益债B 3\n广发中证传媒ETF联接A 4\n中欧新趋势混合A 3\n工银高质量成长混合A 1\n华宝价值发现混合 2\n汇添富蓝筹稳健混合 5\n交银优势行业混合 12\n易方达沪深300医药ETF联接 3\n华宝中证医疗指数 2\n国泰国证房地产行业指数 9\n华宝科技龙头ETF联接A 9\n华安黄金易ETF联接C 8\n国泰国证航天军工指数 2\n大成有色金属期货ETF联接C 2\n国联安半导体ETF联接A 2\n汇添富中证主要消费ETF联接 5\n国泰CES半导体芯片行业ETF联接A 3\n国泰中证生物医药ETF联接A 3\n富国中证科技50ETF联接A 1\n富国中证医药主题指数增强 2\n万家中证500指数增强A 1\n富国中证智能汽车指数 1\n国泰中证煤炭ETF发起式联接C 1\n天弘中证计算机指数A 5\n富国消费升级混合 1\n景顺长城大中华 1\n中欧医疗创新股票C 1\n嘉实智能汽车 1\n华宝资源优选 4\n富国品质生活混合 1\n华宝中证消费龙头指数(LOF)A 2\n易方达消费行业 7\n信达澳银新能源产业 5\n华宝科技ETF联接C 2\n交银阿尔法核心混合 5\n汇添富医药保健混合 2\n易方达安心回馈混合 5\n华夏创新成长ETF联接C 3\n中欧医疗健康混合A 12\n景顺长城鼎益混合(LOF) 3\n广发中证医药卫生  2\n南方中证500ETF联接 5\n鹏华国证钢铁行业指数(LOF) 1\n招商中证煤炭等权指数 3\n富国中证1000指数增强 2\n海富通阿尔法对冲混合C 1\n广发中证基建工程指数A 6\n广发纳斯达克100指数 5\n中信保诚中证800医药指数(LOF) 1\n鹏华中证500 1\n易方达中证军工指数(LOF) 1\n长盛中证全指证券公司指数(LOF) 1\n华夏沪港通恒生ETF联接 4\n国泰大宗商品配置 1\n诺安中证100指数A 1\n广发中证环保ETF联接C 3\n天弘中证医药100C 2\n广发中证军工ETF联接C 1\n南方中证500C 1\n广发中证传媒ETF联接C 5\n前海开源沪深300指数 1\n南方中证全指证券联接C 2\n前海开源中证军工指数A 1\n华安中证500低波ETF联接C 2\n广发可选消费联接C 2\n景顺中证500指数增强 1\n博时中证500指数增强 1\n华安安康灵活配置混合A 1\n中银新回报混合 1\n南方中证房地产联接A 2\n景顺顺益回报C 1\n银河君信混合C 1\n广发医药卫生联接C 4\n广发中证全指家用电器指数A 4\n南方创业板ETF联接 1\n天弘中证食品饮料指数C 3\n嘉实中证500ETF联接 4\n天弘沪深300指数增强A 1\n南方中证有色金属联接A 1\n南方中证银行联接A 1\n中欧责任投资混合A 2\n国泰国证新能源汽车指数 6\n汇添富中证新能源汽车产业指数A 4\n易方达创业板ETF联接A 8\n广发中证军工ETF联接 4\n天弘创业板ETF联接A 3\n鹏华中证信息技术指数(LOF) 2\n华宝券商ETF联接A 5\n华夏中证500ETF联接 1\n工银全球股票(QDII) 2\n中银增利债券 1\n南方天天利货币B 5\n汇添富移动互联股票 2\n工银传媒指数A 1\n中融新经济混合C 2\n泰康中证港股通非银指数C 3\n天弘上证50指数C 2\n广发中证全指家用电器指数C 2\n广发中证500ETF联接（LOF）A类 4\n天弘中证电子ETF联接C 4\n南方中证银行联接C 1\n广发信息技术联接C 4\n银华新能源材料量化优选C 2\n国泰国证食品饮料行业指数 3\n中邮新思路混合 1\n鹏华中证新能源指数 2\n方正富邦中证保险主题指数 7\n银华文体娱乐量化优选C 2\n交银经济新动力混合 3\n交银先进制造混合 1\n交银先锋混合 1\n交银策略回报混合 1\n交银精选混合 2\n交银蓝筹股票 1\n交银稳健配置混合 2\n交银定期支付双息平衡 6\n交银主题优选混合 1\n交银数据产业灵活配置混合 1\n交银中证环境治理指数 1\n交银国证新能源指数（LOF） 1\n交银双轮动债券C 1\n交银国企改革混合 1\n交银全球自然资源 1\n交银趋势优先股票 1\n交银上证180公司治理 1\n交银科技创新混合 1\n景顺长城内需增长 3\n广发优企精选混合 5\n汇添富优势精选混合 2\n易方达沪深300ETF联接 5\n南方MSCI中国A股国际通联接A 1\n华夏中证5G通信主题ETF联接A 1\n景顺长城沪深300指数增强 8\n南方H股联接A 2\n华安行业轮动混合 1\n招商行业精选股票 3\n富国高新技术产业 2\n诺德价值优势混合 1\n广发制造业精选混合 1\n上投摩根新兴动力混合 1\n汇添富消费行业混合 8\n银华心怡混合 2\n南方稳健成长混合 1\n华夏创新前沿股票 2\n银河服务混合 1\n富国天博创新混合 1\n融通行业景气混合 3\n添富红利增长混合C 1\n汇添富全球消费行业混合A 3\n易方达中小盘混合 9\n易方达科翔混合 1\n广发消费品精选混合 2\n银华内需精选混合 2\n工银新生代混合 2\n华夏经济转型股票 1\n鹏华消费优选混合 1\n华泰柏瑞创新升级 3\n嘉实泰和混合 3\n易方达行业领先企业 1\n海富通股票混合 2\n中欧创新成长混合A 2\n银华中小盘精选混合 2\n前海开源量化优选C 1\n创金合信工业周期精选股票C 1\n富国创新科技混合 2\n中银智能制造股票 1\n富国内需增长混合 1\n前海开源医疗健康C 1\n工银前沿医疗股票 6\n前海开源人工智能主题 1\n中银金融地产混合 5\n兴全多维价值混合A 1\n工银消费服务混合 1\n工银信息产业混合 3\n工银战略新兴产业混合A 1\n工银消费股票A 1\n工银战略转型股票 3\n工银美丽城镇股票 1\n工银深证红利联接 6\n中欧时代智慧混合A 1\n万家臻选混合 1\n汇添富文体娱乐主题混合 1\n广发利鑫灵活配置混合A 2\n博时新兴消费主题 1\n广发科技动力股票 1\n嘉实美国成长股票 1\n东方红中证竞争力指数A 1\n工银精选金融地产混合A 3\n汇添富消费升级混合 2\n华宝新兴成长混合 1\n中金MSCI中国A股国际质量指数A 1\n中欧医疗创新股票A 4\n东方红中证竞争力指数C 1\n富国美丽中国混合 1\n朱雀企业优胜A 1\n嘉实价值优势混合 2\n景顺沪港深领先科技 2\n泓德战略转型股票 2\n交银持续成长主题 1\n华安沪港深通精选混合 1\n景顺长城量化新动力 1\n嘉实沪港深精选 1\n华泰柏瑞量化优选 1\n广发钱袋子货币 7\n嘉实优化红利混合 1\n前海开源沪港深龙头精选 1\n富国沪港深行业精选混合 4\n易方达国防军工混合 5\n汇添富医疗服务混合 3\n广发中证能源  1\n广发可选消费联接 2\n华宝美国消费 2\n广发中证信息联接   1\n富国富钱包货币 4\n鹏华香港中小企业指数 2\n博时转债增强债券C 1\n华宝标普油气上游股票人民币A 3\n永赢惠添利混合 3\n富国天合稳健混合 1\n华安成长创新混合 1\n国泰聚信价值优势A 5\n华泰柏瑞价值增长 1\n泰达宏利沪深300增强A 1\n易方达沪深300非银ETF联接 3\n易方达上证中盘ETF联接A 1\n华宝红利基金C 1\n华宝沪港深中国增强(LOF)A 2\n中金沪深300指数增强A 1\n华夏鼎沛债券A 1\n天弘中证中美互联网A 3\n鹏华香港银行指数 1\n泰康中证港股通非银指数A 2\n华宝香港大盘C 1\n嘉实全球互联网股票 1\n汇添富全球医疗保健 1\n交银品质升级混合 1\n天弘创业板ETF联接C 1\n易方达中概互联50ETF联接人民币C 4\n安信量化精选沪深300增强C 3\n华夏上证50AH优选指数（LOF）C 2\n易方达中证红利ETF联接发起式C 1\n华夏沪港通恒生ETF联接C 1\n易方达恒生国企ETF联接C 3\n中金中证500指数增强C 2\n广发纳斯达克100指数C 3\n易方达沪深300ETF联接C 3\n中金中证500指数增强A 1\n易方达中证500ETF联接C 2\n富国中证消费50ETF联接C 3\n国泰家电ETF发起式联接C 1\n易方达上证50ETF联接发起式C 3\n中融央视财经50ETF联接C 3\n嘉实中证主要消费ETF联接C 2\n西部利得中证500指数增强A 1\n浦银安盛沪深300指数增强 1\n工银新蓝筹股票 1\n博时中证全指证券公司指数 1\n富国中国中小盘混合 2\n易方达纳斯达克100指数 5\n海富通阿尔法对冲混合A 7\n创金合信中证红利低波动指数A 1\n兴全合宜混合(LOF)C 1\n富国天惠精选成长混合C 1\n华富成长趋势混合 1\n招商中证全指证券公司指数 3\n汇添富创新医药主题混合 5\n华夏医疗健康混合C 1\n嘉实价值精选股票 5\n新华策略精选股票 2\n工银精选金融地产混合C 1\n南方香港优选股票 1\n华泰柏瑞质量成长 1\n信达澳银先进智造 2\n平安睿享文娱灵活配置混合C 1\n鹏华股息龙头ETF联接C类 1\n鹏华中证医药卫生指数 1\n鹏华中证国防指数(LOF) 2\n鹏华中证酒指数(LOF) 1\n鹏华中证500ETF联接C 1\n汇添富大盘核心资产增长混合 1\n汇添富环保行业股票 1\n汇添富民营活力 1\n国富弹性市值混合 1\n天弘中证电子ETF联接A 1\n富国中证全指证券公司指数 1\n信诚基建工程（LOF） 1\n嘉实恒生国企指数 3\n中欧价值智选回报A 1\n华夏价值精选混合 1\n华夏聚丰混合（FOF）A 1\n大成中小盘混合 1\n海富通内需热点混合 1\n华夏新起点混合 1\n华安生态优先混合 2\n景顺长城品质投资 2\n华泰柏瑞行业领先 1\n华宝香港大盘A 5\n鹏华中证800地产指数(LOF) 1\n天弘中证证券保险指数A 2\n申万菱信中小板指数 1\n易方达增强回报债A 3\n嘉实新兴市场债券 1\n广发医疗指数LOF 1\n汇添富中证生物科技指数C 1\n博时标普500ETF联接 3\n华泰柏瑞稳健收益债C 1\n博时信用债纯债C 2\n华夏海外收益债券A 1\n长信内需成长混合A 1\n银河创新混合 2\n易方达裕丰回报 3\n国泰中证全指通信设备ETF联接基金A 2\n天弘中证银行指数C 3\n泰康港股通TMT指数C 1\n中邮双动力混合 1\n天弘中证证券保险指数C 2\n国投瑞银白银期货（LOF） 2\n博时创业成长混合A 1\n国泰现金管理货币A 1\n中银中高等级债券C 1\n华夏鼎茂债券A 1\n国泰江源优势混合A 2\n富国转型机遇混合 1\n国泰区位优势混合 1\n国泰蓝筹精选混合C 1\n国泰黄金ETF联接A 1\n易方达中债7-10年国开债指数 2\n国泰互联网+股票 1\n国泰融安多策略灵活配置混合 1\n国泰景气行业混合 1\n国泰成长优选混合 1\n国泰事件驱动混合 1\n国泰优势行业混合 1\n国泰金马稳健回报 1\n国泰创业板指数 1\n华夏亚债中国指数C 1\n融通行业景气C 1\n华夏亚债中国指数A 1\n国泰民安增利债券C 1\n国泰利是宝货币 1\n国泰货币基金 1\n国泰民安增益纯债A 1\n国富估值优势混合 1\n安信量化精选沪深300增强A 1\n大成纳斯达克100指数 3\n嘉实中证主要消费ETF联接A 1\n国泰新能源汽车ETF发起式联接A 1\n易方达金融行业股票 1\n富国新动力混合A 4\n银华中证全指医药卫生指数增强 1\n易方达标普生物科技 1\n汇添富中证港股通（LOF）A 2\n申万菱信新能源汽车主题 2\n广发双擎升级混合 3\n中欧电子信息产业沪港深 1\n万家行业优选混合 7\n富国中证银行指数 2\n广发多元新兴股票 3\n泓德臻远回报混合 3\n国泰金牛创新成长 1\n鹏华创业板指数(LOF) 1\n易方达中证银行指数A 1\n易方达供给改革混合 2\n国泰国证有色金属行业指数 5\n创金合信恒兴中短债债券A 1\n创金合信工业周期精选股票A 2\n广发中证金融地产  2\n创金合信科技成长A 2\n鹏华中证A股资源产业指数(LOF) 1\n广发全指工业ETF联接 1\n创金合信金融地产股票A 2\n长信可转债A 1\n广发趋势优选灵活配置混合 3\n华夏沪深300ETF联接 1\n国富中国收益混合 1\n易方达平稳增长混合 1\n泓德致远混合A 5\n易方达瑞和混合 1\n安信新价值混合A 1\n诺德成长优势混合 1\n华安安顺混合 1\n国寿安保稳惠混合 1\n国泰沪深300增强A 1\n泰康新机遇混合 1\n汇添富中证互联网医疗指数C 1\n天弘互联网混合 1\n嘉实沪深300ETF联接(LOF)A 1\n博时黄金ETF联接A 1\n万家沪深300指数增强A 1\n南方上证50增强A 1\n华泰柏瑞中证500ETF联接A 1\n华宝券商ETF联接C 3\n华夏国证半导体芯片ETF联接C 1\n银华中证5G通信主题ETF联接 1\n国泰智能汽车股票A 1\n富国军工主题混合 3\n国泰上证金融ETF联接 1\n博时黄金ETF联接C 2\n易方达稳健收益债A 1\n招商境远保本混合 1\n招商安泰平衡 1\n招商制造业混合 1\n招商丰韵混合C 1\n招商沪深300指数增强C 1\n招商医药股票 2\n招商核心价值混合 1\n招商先锋基金 1\n创金合信消费主题股票A 1\n创金合信新能源汽车股票C 1\n创金合信资源主题精选A 1\n创金合信新能源汽车股票A 1\n创金合信转债精选债券A 1\n华安中证银行指数 2\n国泰国证医药卫生行业指数 2\n建信中证500指数增强A 3\n招商央视50指数 2\n工银产业债券A 1\n汇添富双利债券A 1\n泓德裕康债券A 1\n广发聚鑫债券A 1\n鹏华优势企业股票 1\n景顺长城中证500联接 1\n景顺长城景颐双利C 1\n景顺长城内需增长贰号 1\n景顺长城环保优势 2\n景顺长城中证沪港深红利低波A 1\n景顺稳定收益债A 1\n南方转型混合 1\n南方智慧精选混合 1\n广发沪港深新起点股票A 3\n南方创新经济 1\n南方安福混合C 1\n广发沪港深股票 1\n中欧行业成长混合A 1\n南方金融主题混合 1\n南方国策动力 1\n南方天元 1\n工银医疗保健股票 1\n易方达标普500指数 2\n银华汇利灵活配置混合C 1\n银华信用四季红债券 1\n银华心诚混合 1\n银华和谐主题混合 1\n银华长丰混合发起式 1\n银华兴盛股票 1\n银华富裕主题混合 1\n银华中债AAA信用债指数C 1\n银华深证100指数(LOF) 1\n中欧可转债债券A 2\n汇添富可转换债券A 1\n广发聚宝混合A 1\n富国产业债债券 1\n富国创业板指数 2\n博时裕富沪深300指数A 1\n易方达信用债A 3\n博时信用债纯债A 1\n汇添富精选美元债A 1\n中欧互联网先锋混合A 1\n新华资源混合 1\n易方达信息产业混合 1\n宝盈先进制造混合A 1\n汇添富中证新能源汽车产业指数C 1\n国泰新能源汽车ETF发起式联接C 1\n广发创业板ETF联接C 2\n广发金融地产联接C 1\n国泰CES半导体芯片行业ETF联接C 1\n广发中债7-10年国开债指数C 1\n华夏上证50ETF联接 1\n广发沪深300ETF联接C 1\n广发中证全指建筑材料指数C 1\n前海开源金银珠宝C 1\n南方中证房地产联接C 1\n广发中证全指汽车指数C 1\n华安添鑫中短债A 1\n华安新丝路主题 1\n华安低碳生活混合 2\n华安双债A 1\n华安升级主题混合 1\n华安策略优选混合 1\n华安鼎丰债券 1\n博时宏观回报债券C 1\n博时富瑞纯债C 1\n博时汇智回报混合 1\n博时逆向投资混合C 1\n华安智能生活混合 1\n广发聚鑫债券C 1\n博时回报混合 1\n博时厚泽回报混合C 1\n博时价值增长混合 1\n嘉实主题新动力混合 1\n博时中证500指数增强C 1\n华安中证细分医药ETF联接C 2\n易方达创业板指数ETF联接C 1\n博时鑫泰混合C 1\n易方达裕祥回报债券 2\n安信稳健增值混合C 1\n博时沪深300指数C 1\n博时上证50ETF联接 2\n博时安盈债券C 1\n汇添富中证全指证券公司指数C 1\n招商双债增强债券 1\n大成景安短融债券A 1\n大摩优质信价纯债A 1\n博时鑫源混合C 1\n交银优选回报A 2\n中银多策略混合 1\n光大安和债券A 1\n华宝量化对冲策略A 2\n广发纯债债券C 1\n易方达投资级信用债C 1\n安信新回报混合A 1\n国投瑞银先进制造混合 1\n国投瑞银双债债券A 1\n国投瑞银恒泽中短债A 1\n国投瑞银新兴产业混合（LOF） 1\n国投瑞银锐意改革混合 1\n国投瑞银新机遇混合A 1\n国投瑞银港股通价值发现混合 1\n国投瑞银医疗保健混合 1\n国投瑞银美丽中国混合 1\n华宝沪深300增强 1\n华宝标普中国A股质量价值 1\n华夏沪深300指数增强A 1\n招商产业债券 2\n金鹰信息产业股票A 1\n汇安沪深300指数增强A 1\n华夏创蓝筹ETF联接A 1\n中海医药健康产业C 1\n招商中证银行指数 1\n建信中证红利潜力指数A 1\n广发全球医疗保健 1\n招商国证生物医药指数 2\n天弘中证光伏A 1\n汇丰晋信恒生龙头指数A 1\n浦银安盛沪港深基本面100指数 1\n南方恒生中国企业精明指数A 1\n鹏华中证银行指数(LOF) 1\n国联安中证医药100指数 1\n广发恒生中型股指数（LOF）A类 1\n银河定投宝腾安指数 1\n广发中证环保ETF联接A 1\n益民中证智能消费指数 1\n嘉实策略增长混合 1\n万家和谐增长混合 1\n国富研究精选混合 1\n华宝动力组合基金 1\n申万菱信新经济混合 1\n景顺长城优选混合 1\n创金合信沪深300指数增强C 1\n天弘中证500指数增强C 1\n鹏华外延成长混合 1\n鹏华产业精选混合 1\n鹏华研究精选混合 1\n鹏华精选成长混合 1\n鹏华先进制造股票 1\n鹏华环保产业股票 1\n鹏华沪深港互联网 1\n天弘港股通精选A 2\n中欧先进制造股票A 1\n国联安主题驱动 1\n国联安鑫安混合 1\n国联安添鑫混合A 1\n国联安锐意成长 1\n国联安鑫享混合 1\n天弘中证食品饮料指数A 1\n富国沪港深价值精选 1\n国富中小盘股票 1\n景顺长城绩优成长混合 3\n南方优选成长混合 2\n汇添富成长焦点 2\n易方达消费精选股票 2\n大成标普500 1\n易方达中证500ETF联接A 1\n汇添富中证全指证券公司指数A 1\n中证银行ETF联接基金C 1\n广发消费升级股票 1\n广发量化多因子混合 1\n广发策略优选 1\n广发轮动配置混合 1\n广发医疗保健股票A 2\n广发新兴产业混合 1\n广发品牌消费股票 1\n广发聚瑞混合 1\n广发电子信息传媒产业精选 1\n广发新经济混合 1\n工银双利债券A 1\n交银优择回报A 1\n南方10年国债C 1\n华夏粤港澳大湾区创新100ETF联接A 1\n创金合信中证500指数增强A 1\n易方达中债新综合债券指数A 1\n华宝宝康债券 1\n华宝新活力混合 1\n华宝先进成长 1\n华宝大盘精选 1\n华宝量化对冲策略C 1\n华宝中证100指数 1\n泓德量化精选混合 1\n泓德睿泽混合 1\n泓德泓汇混合 1\n泓德优势领航混合 1\n泓德泓华混合 1\n泓德优选成长混合 2\n泓德泓利货币A 1\n泓德裕丰中短债债券A 1\n易方达港股通红利 1\n鹏华改革红利 1\n博时精选混合 1\n华夏军工安全混合 1\n华夏回报混合 1\n泰达宏利风险预算 1\n南方宝元债券 2\n宝盈互联网沪港深混合 1\n中泰开阳价值优选混合A 1\n宝盈鸿利收益灵活配置混合A 1\n宝盈研究精选混合A 1\n工银圆兴混合 2\n华泰保兴吉年丰A 1\n鹏华养老产业股票 1\n融通健康产业混合 2\n华安创业板50ETF联接A 1\n华安沪深300ETF联接C 1\n华安CES港股通精选100ETF联接C 1\n易方达深证100ETF联接C 1\n华泰柏瑞沪深300ETF联接A 1\n华安上证180联接 1\n华安创业板50指数 2\n大摩强收益债券 2\n鹏华研究智选混合 1\n广发小盘成长混合（LOF） 1\n鹏扬中证500质量成长A 1\n富国中证价值ETF联接 1\n工银新金融股票 2\n中海量化策略混合 1\n万家恒利债券A 1\n大成有色金属期货ETF联接A 1\n交银丰润收益债C 1\n华安安信消费混合 1\n万家恒利债券C 1\n工银绝对收益混合B 1\n易MSCIA股ETF联接A 1\n富国信用债债券A 3\n广发高端制造股票 1\n中欧消费主题股票A 1\n融通产业趋势股票 1\n建信中债国开行债C 1\n建信鑫泽回报混合C 1\n建信沪深300指数增强C 1\n华夏创蓝筹ETF联接C 1\n建信中证500指数增强C 1\n富国天益价值混合 1\n宝盈品牌消费股票A 1\n广发内需增长混合A 1\n鹏华双债增利债券 1\n南方安泰混合 1\n易方达纯债A 1\n兴业添利债券 1\n博时丝路主题股票A 1\n景顺长城成长之星 1\n工银养老产业股票 1\n中海医疗保健主题股票 1\n民生加银策略精选 1\n广发稳健增长混合C类 1\n"
     ]
    }
   ],
   "source": [
    "result={}\n",
    "for item in fund_dict:\n",
    "    print(item,len(fund_dict[item]))\n",
    "    result[item]=len(fund_dict[item])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "[('易方达蓝筹精选混合', 21),\n",
       " ('易方达中概互联50ETF联接人民币A', 19),\n",
       " ('富国天惠成长LOF', 15),\n",
       " ('工银金融地产混合', 14),\n",
       " ('交银新成长混合', 13),\n",
       " ('兴全趋势', 12),\n",
       " ('广发稳健增长混合A类', 12),\n",
       " ('兴全合润混合', 12),\n",
       " ('富国中证红利指数增强', 11),\n",
       " ('华夏上证50AH优选指数（LOF）A', 11),\n",
       " ('汇添富价值精选混合', 11),\n",
       " ('景顺长城中证500低波动', 10),\n",
       " ('易方达上证50指数A', 10),\n",
       " ('国富沪港深成长精选股票', 10),\n",
       " ('工银文体产业股票', 10),\n",
       " ('华夏恒生ETF联接', 10),\n",
       " ('华宝香港中小', 9),\n",
       " ('中欧新蓝筹混合A', 9),\n",
       " ('交银新生活力混合', 9),\n",
       " ('嘉实港股通新经济指数A', 9),\n",
       " ('国泰国证房地产行业指数', 9),\n",
       " ('富国中证500指数增强', 9),\n",
       " ('兴全商业模式优选', 8),\n",
       " ('兴全合宜混合（LOF）A', 8),\n",
       " ('中欧医疗健康混合A', 8),\n",
       " ('景顺长城沪深300指数增强', 8),\n",
       " ('交银中证海外中国互联网指数', 7),\n",
       " ('银河沪深300价值指数', 7),\n",
       " ('天弘中证银行指数A', 7),\n",
       " ('易方达H股ETF联接', 7),\n",
       " ('交银优势行业混合', 7),\n",
       " ('招商中证白酒指数', 7),\n",
       " ('大成中证红利指数A', 6),\n",
       " ('招商沪深300地产等权重指数', 6),\n",
       " ('华宝科技龙头ETF联接A', 6),\n",
       " ('方正富邦中证保险主题指数', 6),\n",
       " ('万家行业优选混合', 6),\n",
       " ('前海开源沪港深优势精选', 5),\n",
       " ('易方达亚洲精选', 5),\n",
       " ('华安黄金易ETF联接A', 5),\n",
       " ('国富大中华精选混合(QDII)人民币', 5),\n",
       " ('汇添富全球移动互联网', 5),\n",
       " ('兴全沪深300指数增强A', 5),\n",
       " ('富国中证新能源汽车指数', 5),\n",
       " ('易方达安心回馈混合', 5),\n",
       " ('富国沪深300增强', 5),\n",
       " ('易方达创业板ETF联接A', 5),\n",
       " ('景顺长城新兴成长', 5),\n",
       " ('易方达国防军工混合', 5),\n",
       " ('华安纳斯达克100指数', 5),\n",
       " ('工银深证红利联接', 5),\n",
       " ('海富通阿尔法对冲混合A', 5),\n",
       " ('汇添富创新医药主题混合', 5),\n",
       " ('嘉实价值精选股票', 5),\n",
       " ('国泰国证有色金属行业指数', 5),\n",
       " ('易方达中小盘混合', 5),\n",
       " ('嘉实深证基本面120联接', 4),\n",
       " ('富国中证消费50ETF联接A', 4),\n",
       " ('博时军工主题股票', 4),\n",
       " ('鹏华中证传媒指数(LOF)', 4),\n",
       " ('中欧新动力混合A', 4),\n",
       " ('华宝中证银行ETF联接A', 4),\n",
       " ('南方中证全指证券联接A', 4),\n",
       " ('华安黄金易ETF联接C', 4),\n",
       " ('华宝资源优选', 4),\n",
       " ('天弘中证500指数增强A', 4),\n",
       " ('天弘中证计算机指数A', 4),\n",
       " ('汇添富消费行业混合', 4),\n",
       " ('工银前沿医疗股票', 4),\n",
       " ('中欧医疗创新股票A', 4),\n",
       " ('国泰聚信价值优势A', 4),\n",
       " ('华宝红利基金', 4),\n",
       " ('易方达纳斯达克100指数', 4),\n",
       " ('汇添富中证主要消费ETF联接', 4),\n",
       " ('易方达消费行业', 4),\n",
       " ('华宝香港大盘A', 4),\n",
       " ('华宝券商ETF联接A', 4),\n",
       " ('泓德致远混合A', 4),\n",
       " ('交银定期支付双息平衡', 4),\n",
       " ('南方宝元债券C', 3),\n",
       " ('鹏扬泓利债券C', 3),\n",
       " ('嘉实基本面50指数(LOF)A', 3),\n",
       " ('中欧价值发现混合C', 3),\n",
       " ('鹏华新兴产业混合', 3),\n",
       " ('创金合信医疗保健股票A', 3),\n",
       " ('景顺长城能源基建', 3),\n",
       " ('易方达安盈回报混合', 3),\n",
       " ('南方原油', 3),\n",
       " ('中欧潜力价值混合', 3),\n",
       " ('中欧新趋势混合A', 3),\n",
       " ('易方达沪深300医药ETF联接', 3),\n",
       " ('国泰中证申万证券行业指数', 3),\n",
       " ('景顺长城鼎益混合(LOF)', 3),\n",
       " ('广发纳斯达克100指数', 3),\n",
       " ('申万菱信中证500指数增强', 3),\n",
       " ('天弘中证医药100A', 3),\n",
       " ('嘉实中证500ETF联接', 3),\n",
       " ('南方中证500ETF联接', 3),\n",
       " ('广发全球精选股票', 3),\n",
       " ('天弘中证电子ETF联接C', 3),\n",
       " ('景顺长城内需增长', 3),\n",
       " ('广发优企精选混合', 3),\n",
       " ('汇添富蓝筹稳健混合', 3),\n",
       " ('易方达沪深300ETF联接', 3),\n",
       " ('招商行业精选股票', 3),\n",
       " ('交银阿尔法核心混合', 3),\n",
       " ('工银信息产业混合', 3),\n",
       " ('工银精选金融地产混合A', 3),\n",
       " ('广发中证基建工程指数A', 3),\n",
       " ('安信量化精选沪深300增强C', 3),\n",
       " ('易方达沪深300ETF联接C', 3),\n",
       " ('南方500信息联接', 3),\n",
       " ('嘉实恒生国企指数', 3),\n",
       " ('易方达增强回报债A', 3),\n",
       " ('富国沪港深行业精选混合', 3),\n",
       " ('广发双擎升级混合', 3),\n",
       " ('广发多元新兴股票', 3),\n",
       " ('华宝券商ETF联接C', 3),\n",
       " ('易方达安心回报债A', 3),\n",
       " ('易方达信用债A', 3),\n",
       " ('中欧时代先锋', 3),\n",
       " ('景顺长城绩优成长混合', 3),\n",
       " ('易方达标普信息科技', 2),\n",
       " ('工银双利债券B', 2),\n",
       " ('申万菱信沪深300价值指数', 2),\n",
       " ('国泰聚信价值优势C', 2),\n",
       " ('南方香港成长', 2),\n",
       " ('中欧价值发现混合A', 2),\n",
       " ('嘉实新能源新材料A', 2),\n",
       " ('上投摩根中国生物医药(QDII)', 2),\n",
       " ('华宝创新混合', 2),\n",
       " ('南方中证有色金属联接C', 2),\n",
       " ('鹏华中证全指证券公司指数(LOF)', 2),\n",
       " ('万家新利混合', 2),\n",
       " ('天弘越南市场股票A', 2),\n",
       " ('兴全轻资产', 2),\n",
       " ('兴全合泰混合A', 2),\n",
       " ('兴全精选混合', 2),\n",
       " ('华宝价值发现混合', 2),\n",
       " ('华宝中证医疗指数', 2),\n",
       " ('大成有色金属期货ETF联接C', 2),\n",
       " ('华夏创新成长ETF联接C', 2),\n",
       " ('华夏沪港通恒生ETF联接', 2),\n",
       " ('广发中证传媒ETF联接C', 2),\n",
       " ('南方中证房地产联接A', 2),\n",
       " ('广发中证全指家用电器指数A', 2),\n",
       " ('天弘中证食品饮料指数C', 2),\n",
       " ('中欧责任投资混合A', 2),\n",
       " ('国联安半导体ETF联接C', 2),\n",
       " ('中融新经济混合C', 2),\n",
       " ('泰康中证港股通非银指数C', 2),\n",
       " ('广发中证500ETF联接（LOF）A类', 2),\n",
       " ('广发信息技术联接C', 2),\n",
       " ('交银经济新动力混合', 2),\n",
       " ('汇添富中证新能源汽车产业指数A', 2),\n",
       " ('南方H股联接A', 2),\n",
       " ('富国高新技术产业', 2),\n",
       " ('富国创新科技混合', 2),\n",
       " ('广发利鑫灵活配置混合A', 2),\n",
       " ('嘉实价值优势混合', 2),\n",
       " ('景顺沪港深领先科技', 2),\n",
       " ('永赢惠添利混合', 2),\n",
       " ('易方达沪深300非银ETF联接', 2),\n",
       " ('天弘中证中美互联网A', 2),\n",
       " ('泰康中证港股通非银指数A', 2),\n",
       " ('易方达中概互联50ETF联接人民币C', 2),\n",
       " ('华夏上证50AH优选指数（LOF）C', 2),\n",
       " ('工银深证红利ETF联接C', 2),\n",
       " ('易方达恒生国企ETF联接C', 2),\n",
       " ('中金中证500指数增强C', 2),\n",
       " ('广发纳斯达克100指数C', 2),\n",
       " ('富国中国中小盘混合', 2),\n",
       " ('国泰中证生物医药ETF联接A', 2),\n",
       " ('新华策略精选股票', 2),\n",
       " ('汇添富全球消费行业混合A', 2),\n",
       " ('广发中证军工ETF联接', 2),\n",
       " ('国泰国证新能源汽车指数', 2),\n",
       " ('华安生态优先混合', 2),\n",
       " ('华泰柏瑞创新升级', 2),\n",
       " ('天弘中证证券保险指数A', 2),\n",
       " ('广发中证养老', 2),\n",
       " ('银河创新混合', 2),\n",
       " ('建信深证基本面60ETF联接A', 2),\n",
       " ('易方达裕丰回报', 2),\n",
       " ('国泰江源优势混合A', 2),\n",
       " ('易方达中债7-10年国开债指数', 2),\n",
       " ('大成纳斯达克100指数', 2),\n",
       " ('中银金融地产混合', 2),\n",
       " ('富国新动力混合A', 2),\n",
       " ('申万菱信新能源汽车主题', 2),\n",
       " ('长信军工量化混合', 2),\n",
       " ('嘉实新兴产业', 2),\n",
       " ('富国中证银行指数', 2),\n",
       " ('泓德臻远回报混合', 2),\n",
       " ('易方达供给改革混合', 2),\n",
       " ('创金合信工业周期精选股票A', 2),\n",
       " ('创金合信科技成长A', 2),\n",
       " ('创金合信金融地产股票A', 2),\n",
       " ('华安德国30（DAX）ETF联接', 2),\n",
       " ('工银战略转型股票', 2),\n",
       " ('天弘创业板ETF联接A', 2),\n",
       " ('兴全可转债', 2),\n",
       " ('博时黄金ETF联接C', 2),\n",
       " ('招商医药股票', 2),\n",
       " ('建信中证500指数增强A', 2),\n",
       " ('华宝标普油气上游股票人民币A', 2),\n",
       " ('招商央视50指数', 2),\n",
       " ('广发沪港深新起点股票A', 2),\n",
       " ('中欧可转债债券A', 2),\n",
       " ('博时信用债券A', 2),\n",
       " ('富国创业板指数', 2),\n",
       " ('华安低碳生活混合', 2),\n",
       " ('交银优选回报A', 2),\n",
       " ('申万菱信中证500指数优选增强', 2),\n",
       " ('招商产业债券', 2),\n",
       " ('招商国证生物医药指数', 2),\n",
       " ('天弘港股通精选A', 2),\n",
       " ('南方优选成长混合', 2),\n",
       " ('汇添富成长焦点', 2),\n",
       " ('易方达消费精选股票', 2),\n",
       " ('广发医疗保健股票A', 2),\n",
       " ('富国军工主题混合', 2),\n",
       " ('南方宝元债券', 2),\n",
       " ('工银圆兴混合', 2),\n",
       " ('大摩强收益债券', 2),\n",
       " ('工银新金融股票', 2),\n",
       " ('融通行业景气混合', 2),\n",
       " ('富国信用债债券A', 2),\n",
       " ('东方红策略精选C', 1),\n",
       " ('南方安裕混合C', 1),\n",
       " ('广发趋势优选混合C', 1),\n",
       " ('中欧时代先锋股票C', 1),\n",
       " ('中欧行业成长混合（LOF）C', 1),\n",
       " ('中欧新动力混合（LOF）C', 1),\n",
       " ('中欧明睿新起点混合', 1),\n",
       " ('中欧数据挖掘混合C', 1),\n",
       " ('中欧养老混合', 1),\n",
       " ('中欧医疗健康混合C', 1),\n",
       " ('中欧消费主题股票C', 1),\n",
       " ('诺安研究精选股票', 1),\n",
       " ('前海开源再融资股票', 1),\n",
       " ('富国互联科技股票', 1),\n",
       " ('银华体育文化混合', 1),\n",
       " ('中欧品质消费股票A', 1),\n",
       " ('华安中证全指证券公司指数', 1),\n",
       " ('富国蓝筹精选股票', 1),\n",
       " ('西部利得中证500指数增强C', 1),\n",
       " ('方正富邦红利精选', 1),\n",
       " ('长城环保主题混合', 1),\n",
       " ('上投摩根科技前沿混合', 1),\n",
       " ('泓德远见回报混合', 1),\n",
       " ('安信价值精选股票', 1),\n",
       " ('泓德泓益混合', 1),\n",
       " ('东方红沪港深混合', 1),\n",
       " ('鹏扬景升混合A', 1),\n",
       " ('财通价值动量混合', 1),\n",
       " ('中欧新动力混合', 1),\n",
       " ('中银转债增强债券A', 1),\n",
       " ('诺安成长混合', 1),\n",
       " ('博时裕隆混合', 1),\n",
       " ('东方红睿丰混合', 1),\n",
       " ('兴全绿色投资', 1),\n",
       " ('华安沪港深外延增长', 1),\n",
       " ('工银高质量成长混合A', 1),\n",
       " ('国泰国证航天军工指数', 1),\n",
       " ('富国消费升级混合', 1),\n",
       " ('景顺长城大中华', 1),\n",
       " ('中欧医疗创新股票C', 1),\n",
       " ('嘉实智能汽车', 1),\n",
       " ('富国品质生活混合', 1),\n",
       " ('中信保诚中证800医药指数(LOF)', 1),\n",
       " ('鹏华中证500', 1),\n",
       " ('易方达中证军工指数(LOF)', 1),\n",
       " ('长盛中证全指证券公司指数(LOF)', 1),\n",
       " ('华宝中证消费龙头指数(LOF)A', 1),\n",
       " ('国泰大宗商品配置', 1),\n",
       " ('诺安中证100指数A', 1),\n",
       " ('广发可选消费联接C', 1),\n",
       " ('景顺中证500指数增强', 1),\n",
       " ('广发中证基建工程指数C', 1),\n",
       " ('博时中证500指数增强', 1),\n",
       " ('华安安康灵活配置混合A', 1),\n",
       " ('中银新回报混合', 1),\n",
       " ('景顺顺益回报C', 1),\n",
       " ('银河君信混合C', 1),\n",
       " ('南方创业板ETF联接', 1),\n",
       " ('天弘沪深300指数增强A', 1),\n",
       " ('南方中证有色金属联接A', 1),\n",
       " ('南方中证银行联接A', 1),\n",
       " ('天弘上证50指数C', 1),\n",
       " ('广发中证全指家用电器指数C', 1),\n",
       " ('南方中证银行联接C', 1),\n",
       " ('银华新能源材料量化优选C', 1),\n",
       " ('交银先进制造混合', 1),\n",
       " ('交银先锋混合', 1),\n",
       " ('交银精选混合', 1),\n",
       " ('汇添富优势精选混合', 1),\n",
       " ('南方MSCI中国A股国际通联接A', 1),\n",
       " ('华夏中证5G通信主题ETF联接A', 1),\n",
       " ('华安行业轮动混合', 1),\n",
       " ('前海开源量化优选C', 1),\n",
       " ('创金合信工业周期精选股票C', 1),\n",
       " ('中银智能制造股票', 1),\n",
       " ('富国内需增长混合', 1),\n",
       " ('前海开源医疗健康C', 1),\n",
       " ('兴全多维价值混合A', 1),\n",
       " ('工银消费服务混合', 1),\n",
       " ('工银战略新兴产业混合A', 1),\n",
       " ('工银消费股票A', 1),\n",
       " ('中欧时代智慧混合A', 1),\n",
       " ('万家臻选混合', 1),\n",
       " ('汇添富文体娱乐主题混合', 1),\n",
       " ('东方红中证竞争力指数A', 1),\n",
       " ('汇添富消费升级混合', 1),\n",
       " ('华宝新兴成长混合', 1),\n",
       " ('中金MSCI中国A股国际质量指数A', 1),\n",
       " ('富国美丽中国混合', 1),\n",
       " ('朱雀企业优胜A', 1),\n",
       " ('泓德战略转型股票', 1),\n",
       " ('中欧创新成长混合A', 1),\n",
       " ('富国天合稳健混合', 1),\n",
       " ('华安成长创新混合', 1),\n",
       " ('泰达宏利沪深300增强A', 1),\n",
       " ('易方达上证中盘ETF联接A', 1),\n",
       " ('华宝红利基金C', 1),\n",
       " ('华宝沪港深中国增强(LOF)A', 1),\n",
       " ('中金沪深300指数增强A', 1),\n",
       " ('华夏鼎沛债券A', 1),\n",
       " ('鹏华香港银行指数', 1),\n",
       " ('嘉实全球互联网股票', 1),\n",
       " ('汇添富全球医疗保健', 1),\n",
       " ('交银品质升级混合', 1),\n",
       " ('天弘创业板ETF联接C', 1),\n",
       " ('易方达中证红利ETF联接发起式C', 1),\n",
       " ('华夏沪港通恒生ETF联接C', 1),\n",
       " ('中金中证500指数增强A', 1),\n",
       " ('易方达中证500ETF联接C', 1),\n",
       " ('西部利得中证500指数增强A', 1),\n",
       " ('浦银安盛沪深300指数增强', 1),\n",
       " ('工银新蓝筹股票', 1),\n",
       " ('博时中证全指证券公司指数', 1),\n",
       " ('创金合信中证红利低波动指数A', 1),\n",
       " ('易方达安心回报债B', 1),\n",
       " ('兴全合宜混合(LOF)C', 1),\n",
       " ('富国天惠精选成长混合C', 1),\n",
       " ('汇添富医药保健混合', 1),\n",
       " ('华富成长趋势混合', 1),\n",
       " ('国泰国证食品饮料行业指数', 1),\n",
       " ('工银精选金融地产混合C', 1),\n",
       " ('南方香港优选股票', 1),\n",
       " ('鹏华股息龙头ETF联接C类', 1),\n",
       " ('鹏华中证医药卫生指数', 1),\n",
       " ('鹏华中证信息技术指数(LOF)', 1),\n",
       " ('鹏华中证国防指数(LOF)', 1),\n",
       " ('鹏华中证酒指数(LOF)', 1),\n",
       " ('汇添富大盘核心资产增长混合', 1),\n",
       " ('汇添富环保行业股票', 1),\n",
       " ('国富弹性市值混合', 1),\n",
       " ('天弘中证电子ETF联接A', 1),\n",
       " ('富国中证全指证券公司指数', 1),\n",
       " ('广发中证传媒ETF联接A', 1),\n",
       " ('国联安半导体ETF联接A', 1),\n",
       " ('信诚基建工程（LOF）', 1),\n",
       " ('中欧价值智选回报A', 1),\n",
       " ('华夏价值精选混合', 1),\n",
       " ('华夏聚丰混合（FOF）A', 1),\n",
       " ('大成中小盘混合', 1),\n",
       " ('海富通内需热点混合', 1),\n",
       " ('华夏新起点混合', 1),\n",
       " ('鹏华中证800地产指数(LOF)', 1),\n",
       " ('申万菱信中小板指数', 1),\n",
       " ('嘉实新兴市场债券', 1),\n",
       " ('广发医疗指数LOF', 1),\n",
       " ('长信内需成长混合A', 1),\n",
       " ('广发消费品精选混合', 1),\n",
       " ('国泰CES半导体芯片行业ETF联接A', 1),\n",
       " ('国泰中证全指通信设备ETF联接基金A', 1),\n",
       " ('国泰现金管理货币A', 1),\n",
       " ('中银中高等级债券C', 1),\n",
       " ('华夏鼎茂债券A', 1),\n",
       " ('富国转型机遇混合', 1),\n",
       " ('国泰区位优势混合', 1),\n",
       " ('国泰蓝筹精选混合C', 1),\n",
       " ('国泰黄金ETF联接A', 1),\n",
       " ('国富估值优势混合', 1),\n",
       " ('安信量化精选沪深300增强A', 1),\n",
       " ('嘉实中证主要消费ETF联接A', 1),\n",
       " ('易方达金融行业股票', 1),\n",
       " ('中欧电子信息产业沪港深', 1),\n",
       " ('易方达沪深300量化增强', 1),\n",
       " ('鹏华创业板指数(LOF)', 1),\n",
       " ('易方达中证银行指数A', 1),\n",
       " ('创金合信恒兴中短债债券A', 1),\n",
       " ('广发中证金融地产 ', 1),\n",
       " ('鹏华中证A股资源产业指数(LOF)', 1),\n",
       " ('广发全指工业ETF联接', 1),\n",
       " ('长信可转债A', 1),\n",
       " ('富国富钱包货币', 1),\n",
       " ('广发趋势优选灵活配置混合', 1),\n",
       " ('南方中证全指证券联接C', 1),\n",
       " ('华夏沪深300ETF联接', 1),\n",
       " ('国富中国收益混合', 1),\n",
       " ('易方达平稳增长混合', 1),\n",
       " ('招商中证煤炭等权指数', 1),\n",
       " ('汇添富中证互联网医疗指数C', 1),\n",
       " ('天弘互联网混合', 1),\n",
       " ('嘉实沪深300ETF联接(LOF)A', 1),\n",
       " ('博时黄金ETF联接A', 1),\n",
       " ('万家沪深300指数增强A', 1),\n",
       " ('南方上证50增强A', 1),\n",
       " ('国泰中证全指通信设备ETF联接基金C', 1),\n",
       " ('天弘中证银行指数C', 1),\n",
       " ('华泰柏瑞中证500ETF联接A', 1),\n",
       " ('华夏国证半导体芯片ETF联接C', 1),\n",
       " ('银华中证5G通信主题ETF联接', 1),\n",
       " ('易方达稳健收益债A', 1),\n",
       " ('招商境远保本混合', 1),\n",
       " ('招商安泰平衡', 1),\n",
       " ('招商制造业混合', 1),\n",
       " ('招商丰韵混合C', 1),\n",
       " ('招商沪深300指数增强C', 1),\n",
       " ('创金合信消费主题股票A', 1),\n",
       " ('创金合信新能源汽车股票C', 1),\n",
       " ('创金合信资源主题精选A', 1),\n",
       " ('华安中证银行指数', 1),\n",
       " ('国泰国证医药卫生行业指数', 1),\n",
       " ('工银产业债券A', 1),\n",
       " ('汇添富双利债券A', 1),\n",
       " ('泓德裕康债券A', 1),\n",
       " ('广发聚鑫债券A', 1),\n",
       " ('鹏华优势企业股票', 1),\n",
       " ('景顺长城中证500联接', 1),\n",
       " ('景顺长城景颐双利C', 1),\n",
       " ('景顺长城内需增长贰号', 1),\n",
       " ('南方转型混合', 1),\n",
       " ('南方智慧精选混合', 1),\n",
       " ('南方创新经济', 1),\n",
       " ('南方安福混合C', 1),\n",
       " ('广发沪港深股票', 1),\n",
       " ('中欧行业成长混合A', 1),\n",
       " ('南方金融主题混合', 1),\n",
       " ('南方国策动力', 1),\n",
       " ('银华汇利灵活配置混合C', 1),\n",
       " ('银华信用四季红债券', 1),\n",
       " ('银华心诚混合', 1),\n",
       " ('银华和谐主题混合', 1),\n",
       " ('银华心怡混合', 1),\n",
       " ('银华内需精选混合', 1),\n",
       " ('银华长丰混合发起式', 1),\n",
       " ('银华兴盛股票', 1),\n",
       " ('汇添富可转换债券A', 1),\n",
       " ('广发聚宝混合A', 1),\n",
       " ('富国产业债债券', 1),\n",
       " ('富国中证1000指数增强', 1),\n",
       " ('博时裕富沪深300指数A', 1),\n",
       " ('博时信用债纯债A', 1),\n",
       " ('中欧互联网先锋混合A', 1),\n",
       " ('汇添富医疗服务混合', 1),\n",
       " ('新华资源混合', 1),\n",
       " ('易方达信息产业混合', 1),\n",
       " ('宝盈先进制造混合A', 1),\n",
       " ('汇添富中证新能源汽车产业指数C', 1),\n",
       " ('华安添鑫中短债A', 1),\n",
       " ('华安新丝路主题', 1),\n",
       " ('华安双债A', 1),\n",
       " ('华安升级主题混合', 1),\n",
       " ('华安策略优选混合', 1),\n",
       " ('华安鼎丰债券', 1),\n",
       " ('博时宏观回报债券C', 1),\n",
       " ('博时富瑞纯债C', 1),\n",
       " ('博时汇智回报混合', 1),\n",
       " ('博时逆向投资混合C', 1),\n",
       " ('华安智能生活混合', 1),\n",
       " ('广发聚鑫债券C', 1),\n",
       " ('易方达裕祥回报债券', 1),\n",
       " ('中银多策略混合', 1),\n",
       " ('安信新回报混合A', 1),\n",
       " ('嘉实泰和混合', 1),\n",
       " ('国投瑞银先进制造混合', 1),\n",
       " ('国投瑞银双债债券A', 1),\n",
       " ('国投瑞银恒泽中短债A', 1),\n",
       " ('国投瑞银新兴产业混合（LOF）', 1),\n",
       " ('国投瑞银锐意改革混合', 1),\n",
       " ('国投瑞银新机遇混合A', 1),\n",
       " ('国投瑞银港股通价值发现混合', 1),\n",
       " ('国投瑞银医疗保健混合', 1),\n",
       " ('华宝沪深300增强', 1),\n",
       " ('华宝标普中国A股质量价值', 1),\n",
       " ('汇添富中证港股通（LOF）A', 1),\n",
       " ('华夏沪深300指数增强A', 1),\n",
       " ('金鹰信息产业股票A', 1),\n",
       " ('汇安沪深300指数增强A', 1),\n",
       " ('华夏创蓝筹ETF联接A', 1),\n",
       " ('中海医药健康产业C', 1),\n",
       " ('招商中证银行指数', 1),\n",
       " ('建信中证红利潜力指数A', 1),\n",
       " ('广发全球医疗保健', 1),\n",
       " ('天弘中证光伏A', 1),\n",
       " ('嘉实策略增长混合', 1),\n",
       " ('万家和谐增长混合', 1),\n",
       " ('国富研究精选混合', 1),\n",
       " ('华宝动力组合基金', 1),\n",
       " ('申万菱信新经济混合', 1),\n",
       " ('嘉实中证主要消费ETF联接C', 1),\n",
       " ('鹏华外延成长混合', 1),\n",
       " ('鹏华产业精选混合', 1),\n",
       " ('鹏华研究精选混合', 1),\n",
       " ('鹏华精选成长混合', 1),\n",
       " ('鹏华先进制造股票', 1),\n",
       " ('鹏华环保产业股票', 1),\n",
       " ('鹏华沪深港互联网', 1),\n",
       " ('华安媒体互联网混合', 1),\n",
       " ('中欧先进制造股票A', 1),\n",
       " ('国联安主题驱动', 1),\n",
       " ('国联安鑫安混合', 1),\n",
       " ('国联安添鑫混合A', 1),\n",
       " ('国联安锐意成长', 1),\n",
       " ('国联安鑫享混合', 1),\n",
       " ('天弘中证食品饮料指数A', 1),\n",
       " ('富国沪港深价值精选', 1),\n",
       " ('国富中小盘股票', 1),\n",
       " ('广发消费升级股票', 1),\n",
       " ('广发量化多因子混合', 1),\n",
       " ('广发策略优选', 1),\n",
       " ('广发轮动配置混合', 1),\n",
       " ('广发新兴产业混合', 1),\n",
       " ('工银双利债券A', 1),\n",
       " ('交银优择回报A', 1),\n",
       " ('博时标普500ETF联接', 1),\n",
       " ('广发钱袋子货币', 1),\n",
       " ('南方10年国债C', 1),\n",
       " ('易方达标普500指数', 1),\n",
       " ('华夏粤港澳大湾区创新100ETF联接A', 1),\n",
       " ('创金合信中证500指数增强A', 1),\n",
       " ('华宝宝康债券', 1),\n",
       " ('华宝新活力混合', 1),\n",
       " ('华宝先进成长', 1),\n",
       " ('华宝大盘精选', 1),\n",
       " ('华宝量化对冲策略C', 1),\n",
       " ('泓德量化精选混合', 1),\n",
       " ('泓德睿泽混合', 1),\n",
       " ('泓德泓汇混合', 1),\n",
       " ('泓德优势领航混合', 1),\n",
       " ('兴全社会责任', 1),\n",
       " ('易方达港股通红利', 1),\n",
       " ('华夏回报混合', 1),\n",
       " ('泰达宏利风险预算', 1),\n",
       " ('工银全球精选股票', 1),\n",
       " ('宝盈互联网沪港深混合', 1),\n",
       " ('中泰开阳价值优选混合A', 1),\n",
       " ('宝盈鸿利收益灵活配置混合A', 1),\n",
       " ('宝盈研究精选混合A', 1),\n",
       " ('中欧明睿新常态混合', 1),\n",
       " ('华泰保兴吉年丰A', 1),\n",
       " ('鹏华养老产业股票', 1),\n",
       " ('华安创业板50ETF联接A', 1),\n",
       " ('华安沪深300ETF联接C', 1),\n",
       " ('华安CES港股通精选100ETF联接C', 1),\n",
       " ('鹏华研究智选混合', 1),\n",
       " ('广发小盘成长混合（LOF）', 1),\n",
       " ('华安创业板50指数', 1),\n",
       " ('中海量化策略混合', 1),\n",
       " ('万家恒利债券A', 1),\n",
       " ('大成有色金属期货ETF联接A', 1),\n",
       " ('南方天天利货币B', 1),\n",
       " ('交银丰润收益债C', 1),\n",
       " ('工银绝对收益混合B', 1),\n",
       " ('广发高端制造股票', 1),\n",
       " ('融通产业趋势股票', 1),\n",
       " ('建信中债国开行债C', 1),\n",
       " ('建信鑫泽回报混合C', 1),\n",
       " ('建信沪深300指数增强C', 1),\n",
       " ('广发医药卫生联接C', 1),\n",
       " ('华夏创蓝筹ETF联接C', 1),\n",
       " ('富国天益价值混合', 1),\n",
       " ('宝盈品牌消费股票A', 1),\n",
       " ('广发内需增长混合A', 1),\n",
       " ('鹏华双债增利债券', 1),\n",
       " ('南方安泰混合', 1),\n",
       " ('易方达纯债A', 1),\n",
       " ('兴业添利债券', 1),\n",
       " ('博时丝路主题股票A', 1),\n",
       " ('景顺长城成长之星', 1),\n",
       " ('工银养老产业股票', 1),\n",
       " ('中海医疗保健主题股票', 1),\n",
       " ('泓德优选成长混合', 1),\n",
       " ('民生加银策略精选', 1),\n",
       " ('广发稳健增长混合C类', 1)]"
      ]
     },
     "metadata": {},
     "execution_count": 15
    }
   ],
   "source": [
    "list(sorted(result.items(),key=lambda x:x[1],reverse=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "Help on built-in function sorted in module builtins:\n\nsorted(iterable, /, *, key=None, reverse=False)\n    Return a new list containing all items from the iterable in ascending order.\n    \n    A custom key function can be supplied to customize the sort order, and the\n    reverse flag can be set to request the result in descending order.\n\n"
     ]
    }
   ],
   "source": [
    "help(sorted)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_=list(sorted(result.items(),key=lambda x:x[1],reverse=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_dict_=[]\n",
    "for name,count in result_:\n",
    "    d={}\n",
    "    d['name']=name\n",
    "    d['count']=count\n",
    "    result_dict_.append(d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "{'name': '广发稳健增长混合C类', 'count': 1}"
      ]
     },
     "metadata": {},
     "execution_count": 21
    }
   ],
   "source": [
    "result_dict_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(result_dict_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "                 name  count\n",
       "0           易方达蓝筹精选混合     21\n",
       "1  易方达中概互联50ETF联接人民币A     19\n",
       "2           富国天惠成长LOF     15\n",
       "3            工银金融地产混合     14\n",
       "4             交银新成长混合     13"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>name</th>\n      <th>count</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>易方达蓝筹精选混合</td>\n      <td>21</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>易方达中概互联50ETF联接人民币A</td>\n      <td>19</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>富国天惠成长LOF</td>\n      <td>15</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>工银金融地产混合</td>\n      <td>14</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>交银新成长混合</td>\n      <td>13</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 24
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('fund_count_.xls',encoding='utf8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "found_day_list=[]\n",
    "for item in doc.find({},{'found_days':1}):\n",
    "    found_day_list.append(item['found_days'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "543.455223880597\n"
     ]
    }
   ],
   "source": [
    "print(np.array(found_day_list).mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "543.455223880597"
      ]
     },
     "metadata": {},
     "execution_count": 43
    }
   ],
   "source": [
    "result_np.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "3.8.3-final"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}